﻿CREATE PROCEDURE [dbo].[proc_Project_Update]
	(
		@ProductId nvarchar(50),
		@CostPrice numeric(18,2),
		@SalePrice numeric(18,2),
		@Description nvarchar(200),
		@TypeId int,
		@SupplierId int,
		@ProjectId uniqueidentifier
	)
AS
	Update Project Set
	ProductId=@ProductId,
	CostPrice=@CostPrice,
	SalePrice=@SalePrice,
	Description=@Description,
	TypeId=@TypeId,
	SupplierId=@SupplierId
	Where ProjectId=@ProjectId
	RETURN
